#!/bin/sh
cptDataDir=/opt/wf/action/dbrecord/JZCpt
dataTable='t_pre_cpt_success_detail_stat_201410'
for f in $(ls $cptDataDir/JZCptSuccessDetail_2014-10*)
do
	loaddata="load data local infile '$f' into table $dataTable CHARACTER SET utf8 fields terminated by '^&' LINES TERMINATED BY '\n';"
	echo $loaddata
	echo $loaddata | mysql --auto-rehash -h10.5.20.27 -P5029 -uhuangliang -pS236XnYhG0VFb2mN15 -D dbwww58com_jingzhun
done
